using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using QuanLyThietBi.Config;     
using QuanLyThietBi.Entity;
namespace QuanLyThietBi.ManagerBase
{
                

     public abstract class TBL_ChiTietYeuCauHoTroKyThuatManagerBase
    {
        public TBL_ChiTietYeuCauHoTroKyThuatManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity Insert(TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity Update(TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.Update(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo dieu kien trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity UpdateWithCondition(TBL_ChiTietYeuCauHoTroKyThuatEntity obj,TBL_ChiTietYeuCauHoTroKyThuatEntity objCond)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.UpdateWithCondition(obj,objCond);             
        }
 
 
        public TBL_ChiTietYeuCauHoTroKyThuatEntity Delete(TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.Delete(obj);             
        }
 
 
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteWithCondition(TBL_ChiTietYeuCauHoTroKyThuatEntity objCond)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteWithCondition(objCond);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByGhiChu (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"GhiChu");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien GhiChu 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByGhiChu (string GhiChu )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.GhiChu = GhiChu;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"GhiChu");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByKetQua (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"KetQua");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien KetQua 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByKetQua (string KetQua )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.KetQua = KetQua;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"KetQua");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaCaBiet (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaCaBiet");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaCaBiet 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaCaBiet (string MaCaBiet )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCaBiet = MaCaBiet;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaCaBiet");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaCTYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaCTYC");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaCTYC 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaCTYC (Guid MaCTYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCTYC = MaCTYC;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaCTYC");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaLoi (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaLoi");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaLoi 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaLoi (string MaLoi )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaLoi = MaLoi;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaLoi");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaYC");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MaYC 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByMaYC (string MaYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaYC = MaYC;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"MaYC");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByTrangThai (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"TrangThai");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TrangThai 
        /// </summary>
        /// <returns>TBL_ChiTietYeuCauHoTroKyThuatEntity</returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity DeleteByTrangThai (string TrangThai )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.TrangThai = TrangThai;  
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity)Adapter.DeleteByField(obj,"TrangThai");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public TBL_ChiTietYeuCauHoTroKyThuatEntity Select(TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return (TBL_ChiTietYeuCauHoTroKyThuatEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new TBL_ChiTietYeuCauHoTroKyThuatEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new TBL_ChiTietYeuCauHoTroKyThuatEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectAllLST()
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new TBL_ChiTietYeuCauHoTroKyThuatEntity()),new TBL_ChiTietYeuCauHoTroKyThuatEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new TBL_ChiTietYeuCauHoTroKyThuatEntity(),option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGhiChu (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"GhiChu");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGhiChu (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"GhiChu",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByGhiChuLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"GhiChu"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByGhiChuLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"GhiChu",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGhiChu (string GhiChu )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.GhiChu = GhiChu;  
            return Adapter.SelectByField(obj,"GhiChu");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByGhiChu (string GhiChu, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.GhiChu = GhiChu;  
            return Adapter.SelectByField(obj,"GhiChu",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByGhiChuLST (string GhiChu )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.GhiChu = GhiChu;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"GhiChu"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien GhiChu duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByGhiChuLST (string GhiChu, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.GhiChu = GhiChu;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"GhiChu",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByKetQua (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"KetQua");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByKetQua (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"KetQua",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByKetQuaLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"KetQua"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByKetQuaLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"KetQua",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByKetQua (string KetQua )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.KetQua = KetQua;  
            return Adapter.SelectByField(obj,"KetQua");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByKetQua (string KetQua, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.KetQua = KetQua;  
            return Adapter.SelectByField(obj,"KetQua",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByKetQuaLST (string KetQua )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.KetQua = KetQua;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"KetQua"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien KetQua duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByKetQuaLST (string KetQua, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.KetQua = KetQua;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"KetQua",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCaBiet (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"MaCaBiet");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCaBiet (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MaCaBiet",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCaBietLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCaBiet"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCaBietLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MaCaBiet",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCaBiet (string MaCaBiet )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCaBiet = MaCaBiet;  
            return Adapter.SelectByField(obj,"MaCaBiet");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCaBiet (string MaCaBiet, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCaBiet = MaCaBiet;  
            return Adapter.SelectByField(obj,"MaCaBiet",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCaBietLST (string MaCaBiet )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCaBiet = MaCaBiet;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCaBiet"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCaBiet duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCaBietLST (string MaCaBiet, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCaBiet = MaCaBiet;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCaBiet",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCTYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"MaCTYC");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCTYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MaCTYC",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCTYCLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCTYC"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCTYCLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MaCTYC",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCTYC (Guid MaCTYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCTYC = MaCTYC;  
            return Adapter.SelectByField(obj,"MaCTYC");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaCTYC (Guid MaCTYC, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCTYC = MaCTYC;  
            return Adapter.SelectByField(obj,"MaCTYC",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCTYCLST (Guid MaCTYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCTYC = MaCTYC;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCTYC"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaCTYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaCTYCLST (Guid MaCTYC, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaCTYC = MaCTYC;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaCTYC",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaLoi (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"MaLoi");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaLoi (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MaLoi",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaLoiLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaLoi"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaLoiLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MaLoi",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaLoi (string MaLoi )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaLoi = MaLoi;  
            return Adapter.SelectByField(obj,"MaLoi");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaLoi (string MaLoi, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaLoi = MaLoi;  
            return Adapter.SelectByField(obj,"MaLoi",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaLoiLST (string MaLoi )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaLoi = MaLoi;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaLoi"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaLoi duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaLoiLST (string MaLoi, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaLoi = MaLoi;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaLoi",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"MaYC");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaYC (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MaYC",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaYCLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaYC"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaYCLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MaYC",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaYC (string MaYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaYC = MaYC;  
            return Adapter.SelectByField(obj,"MaYC");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMaYC (string MaYC, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaYC = MaYC;  
            return Adapter.SelectByField(obj,"MaYC",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaYCLST (string MaYC )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaYC = MaYC;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaYC"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MaYC duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByMaYCLST (string MaYC, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.MaYC = MaYC;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MaYC",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTrangThai (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return Adapter.SelectByField(obj,"TrangThai");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTrangThai (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TrangThai",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByTrangThaiLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TrangThai"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByTrangThaiLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TrangThai",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTrangThai (string TrangThai )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.TrangThai = TrangThai;  
            return Adapter.SelectByField(obj,"TrangThai");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTrangThai (string TrangThai, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.TrangThai = TrangThai;  
            return Adapter.SelectByField(obj,"TrangThai",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByTrangThaiLST (string TrangThai )
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.TrangThai = TrangThai;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TrangThai"),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TrangThai duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectByTrangThaiLST (string TrangThai, SelectOptions option)
        { 
            TBL_ChiTietYeuCauHoTroKyThuatEntity obj = new TBL_ChiTietYeuCauHoTroKyThuatEntity();
            obj.TrangThai = TrangThai;  
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TrangThai",option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectWithConditionLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<TBL_ChiTietYeuCauHoTroKyThuatEntity></returns>
        public List<TBL_ChiTietYeuCauHoTroKyThuatEntity> SelectWithConditionLST (TBL_ChiTietYeuCauHoTroKyThuatEntity obj,SelectOptions option)
        { 
            return  (List<TBL_ChiTietYeuCauHoTroKyThuatEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new TBL_ChiTietYeuCauHoTroKyThuatEntity());
        }

}
}
